Дана таблица orders с колонками order_id, customer_id, order_date, total_amount. Какой из следующих SQL запросов вернет топ-3 месяца с наибольшим количеством заказов?
A) SELECT MONTH(order_date) AS month, SUM(total_amount) AS total_order_amount FROM orders GROUP BY month ORDER BY total_order_amount DESC LIMIT 3;
B) SELECT EXTRACT(MONTH FROM order_date) AS month, SUM(total_amount) AS total_order_amount FROM orders GROUP BY month ORDER BY total_order_amount DESC LIMIT 3;
C) SELECT DATE_TRUNC('month', order_date) AS month, SUM(total_amount) AS total_order_amount FROM orders GROUP BY month ORDER BY total_order_amount DESC LIMIT 3;
D) SELECT STRFTIME('%Y-%m', order_date) AS month, SUM(total_amount) AS total_order_amount FROM orders GROUP BY month ORDER BY total_order_amount DESC LIMIT 3;
Дана таблица orders с колонками order_id, customer_id, order_date, total_amount. Какой из следующих SQL запросов вернет топ-3 месяца с наибольшим количеством заказов?
A) SELECT MONTH(order_date) AS month, SUM(total_amount) AS total_order_amount FROM orders GROUP BY month ORDER BY total_order_amount DESC LIMIT 3;
B) SELECT EXTRACT(MONTH FROM order_date) AS month, SUM(total_amount) AS total_order_amount FROM orders GROUP BY month ORDER BY total_order_amount DESC LIMIT 3;
C) SELECT DATE_TRUNC('month', order_date) AS month, SUM(total_amount) AS total_order_amount FROM orders GROUP BY month ORDER BY total_order_amount DESC LIMIT 3;
D) SELECT STRFTIME('%Y-%m', order_date) AS month, SUM(total_amount) AS total_order_amount FROM orders GROUP BY month ORDER BY total_order_amount DESC LIMIT 3;
Ответить на вопрос можно ниже ⬇️
BY SQL для тестировщика
Warning: Undefined variable $i in /var/www/tg-me/post.php on line 283
The cloud-based messaging platform is also adding Anonymous Group Admins feature. As per Telegram, this feature is being introduced for safer protests. As per the Telegram blog post, users can “Toggle Remain Anonymous in Admin rights to enable Batman mode. The anonymized admin will be hidden in the list of group members, and their messages in the chat will be signed with the group name, similar to channel posts.”
How Does Telegram Make Money?
Telegram is a free app and runs on donations. According to a blog on the telegram: We believe in fast and secure messaging that is also 100% free. Pavel Durov, who shares our vision, supplied Telegram with a generous donation, so we have quite enough money for the time being. If Telegram runs out, we will introduce non-essential paid options to support the infrastructure and finance developer salaries. But making profits will never be an end-goal for Telegram.
